ajTextSplit function
Description
Splits text with a delimiter.
Syntax
ajTextSplit(text, delimiter)
| Argument Name | Argument Type | Description |
|---|---|---|
| text (required) | String | Text to be split with delimiter. |
| delimiter (required) | String | Character or string to split the text. |
The function will return:
- Return Value: A list of split text.
- Return Type: Single Value / Multiple values (array formula)
Example
In this example, we will demonstrate how to split text with a delimiter.
The text value we have set in the B1 is '111,222,333' and uses comma to split the text.
Select a range, for example, B5 to B7, input the formula as shown in Cell B4 and press CTRL + SHIFT + ENTER to make it to be an array formula since it returns a list of text. Both vertical and horizontal array formula are supported.
Error Scenarios
It will return #VALUE! when missing any required parameter or mismatch parameter type.